All files / web/src/app/api/flowcharts/[id] route.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { and, eq } from 'drizzle-orm'
import { NextResponse } from 'next/server'
import { withAuth } from '@/lib/auth/withAuth'
import { db, schema } from '@/db'

/**
 * GET /api/flowcharts/[id]
 * Get a flowchart by ID from the database.
 *
 * NOTE: Built-in flowcharts must be seeded via the Seed Manager
 * (debug mode on /flowchart) before they can be fetched.
 *
 * Returns: { flowchart: { definition, mermaid, meta, source } } or 404
 */
export const GET = withAuth(async (_request, { params }) => {
  try {
    const { id } = (await params) as { id: string }

    // Load from database only
    const dbFlowchart = await db.query.teacherFlowcharts.findFirst({
      where: and(
        eq(schema.teacherFlowcharts.id, id),
        eq(schema.teacherFlowcharts.status, 'published')
      ),
    })

    if (dbFlowchart) {
      let definition
      try {
        definition = JSON.parse(dbFlowchart.definitionJson)
      } catch {
        return NextResponse.json({ error: 'Invalid flowchart definition' }, { status: 500 })
      }

      return NextResponse.json({
        flowchart: {
          definition,
          mermaid: dbFlowchart.mermaidContent,
          meta: {
            id: dbFlowchart.id,
            title: dbFlowchart.title,
            description: dbFlowchart.description || '',
            emoji: dbFlowchart.emoji || '📊',
            difficulty: dbFlowchart.difficulty as 'Beginner' | 'Intermediate' | 'Advanced',
          },
          source: 'database',
          authorId: dbFlowchart.userId,
          version: dbFlowchart.version,
          publishedAt: dbFlowchart.publishedAt,
        },
      })
    }

    return NextResponse.json({ error: 'Flowchart not found' }, { status: 404 })
  } catch (error) {
    console.error('Failed to fetch flowchart:', error)
    return NextResponse.json({ error: 'Failed to fetch flowchart' }, { status: 500 })
  }
})